Xaroth Brook
Minmatar
BIG
Libertas Fidelitas
   |
Posted - 2010.01.19 11:31:00 -
[1]
Dragonaire,
First of all, nice work so far, it was some getting used to due to not having that much information about it, but I got most of it working.
One bit I didn't get working was this:
If you have multiple characters belonging to the same corp, you can still only enter 1 item -per corp- in the utilRegisteredCorporation table.. as such, once there's already somebody in that list with limited view rights (say, normal member), you'll have to manually confirm that the character you are trying to add for that corp has more access than the one already in place, then replace the entry.
how when you then remove that second character, adding the first could be possible with some logic, but then the system would again, try to load API sections it shouldn't be loading.
a small proposed change for this:
allow multiple character-corp entries (and linked as such, primary key on characterID or so), that each have their own activeAPI list.
then, per corp check the list of characters (so you know which api key to use), and check which activeAPI they have set, start with the character that has the most (after verifying it works, obviously), if another character has access to a sheet that hasn't already been processed, use that character to retrieve the information
as such you would end up with a relation like this:
character - access
Char1 - A B C D E
Char2 - A B C D E F G H
Char3 - A C D E F G H I J K L
The system should then use Char3's key to retrieve A (not B as it doesn't have it) C-L .. after loading it should notice that B hasn't been loaded, and that Char2 (seeing it has the most lists available) has that.. 1+1=3, use Char2's access to Load B, and yer done.
that way, if any of the characters gets removed at a later point, the system will remain functional (albeit less data being processed).. also, a new character added to the list with all access will be checked first to verify it's access, after which proper access will be used to pick up the remainder.
It was like a baby, it landed on my lap and was helpless and totally defenseless. Then I shot it and bragged about it on a killboard.
|